UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zn6r++5jIlMN5lN0SUpaZwA3pbLDVRHrbu2Hp3J6e3s='
WHERE
key_id = '4dde7004509aca56b2c95a956e4dadbf3c60bae6b63e0e2324f6f60ade9ae7c7'
AND (
token = 'zn6r++5jIlMN5lN0SUpaZwA3pbLDVRHrbu2Hp3J6e3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)