UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yagbCV00g7JuBYCcnTBnITXoXR0ckpztpPYeFSCCzFQ='
WHERE
key_id = '116ec1c8a5540f0bdfd12cd9e0b02f49f2d6ba6709eca72e025986de4bd8c8ac'
AND (
token = 'yagbCV00g7JuBYCcnTBnITXoXR0ckpztpPYeFSCCzFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)