UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8LOjm1oxBY5PhYAQgPz/OdhnbW9dsv6U1Pui32rlgpA='
WHERE
key_id = '1c0af04548d82395f43623590089525701707240ca4fbcec081c70f9986c4878'
AND (
token = '8LOjm1oxBY5PhYAQgPz/OdhnbW9dsv6U1Pui32rlgpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)