UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z6AaMvnl1m2nppCy3nlEmEGhB//NCVqcdrKJXlYmpVo='
WHERE
key_id = '99a4d45be9e64b38cf42ff1d8fe28f73e0ea97335f945247cb2d29551767f6cd'
AND (
token = 'Z6AaMvnl1m2nppCy3nlEmEGhB//NCVqcdrKJXlYmpVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)