UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8diZCuJBWNV2n4TFaizMV7eDEasbSpA5gOGQ+nKHzbE='
WHERE
key_id = 'acf2ce23b43e35df3abcc5db5670cbd7e45b56f02a279084c69fcf81a1a5f916'
AND (
token = '8diZCuJBWNV2n4TFaizMV7eDEasbSpA5gOGQ+nKHzbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)