UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pcRAJGE2ezdy+CTrr/wgZ1d1nqCPYIq0XKk86yzk1QA='
WHERE
key_id = '1d318137be21094fb5f15759d66232f294a846f8915da5f39dddc421b6f0e1d7'
AND (
token = 'pcRAJGE2ezdy+CTrr/wgZ1d1nqCPYIq0XKk86yzk1QA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)