UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'liesTbOH4fLsI6ZYBGJgPdbkS/uMUy/UyFBi06swqAg='
WHERE
key_id = 'efd90cd15464d35a782a3c402ca9a75ae703e849736e14a101c34246a44a865a'
AND (
token = 'liesTbOH4fLsI6ZYBGJgPdbkS/uMUy/UyFBi06swqAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)