UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NGHbpV6fE0H5sfjJodPnGO2x0uoxQIF1tUW9KX4cT4w='
WHERE
key_id = 'c246e7829bdc7c1f026a93b64a6cbe4c752d605d3c235675de6b9ddf7477ebfa'
AND (
token = 'NGHbpV6fE0H5sfjJodPnGO2x0uoxQIF1tUW9KX4cT4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)