UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Qjnc4o+i6vkeoPGbrz2cgosXz3CQvj4yNIwVn/tBJI='
WHERE
key_id = 'f10bd916710d24dc946e6266e882820e1f4ff31d6f642dfedc329e35fa3d4f97'
AND (
token = '4Qjnc4o+i6vkeoPGbrz2cgosXz3CQvj4yNIwVn/tBJI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)