UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxOiqYQqgh6QkdJVTLyNw3z2mKo6v5wckJ1Xc89S9SI='
WHERE
key_id = '87d27a77cb6de8b3ea8a8bcd9f121ef7aea0410906295c47490f7a0b833185de'
AND (
token = 'zxOiqYQqgh6QkdJVTLyNw3z2mKo6v5wckJ1Xc89S9SI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)