UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nBs8c/0uQvwbK7taoLqv9mp6hqUo5geGlWKcy2rkC5c='
WHERE
key_id = '959026f68b11c0a893d774cffc8c6219904f90e4d4785b130a89d07f171814c5'
AND (
token = 'nBs8c/0uQvwbK7taoLqv9mp6hqUo5geGlWKcy2rkC5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)