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