UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lq6EJvJG0IfYQz/tbbRc7/+1PInvlg9En4pfkpIxyyY='
WHERE
key_id = '0854420cc1907bab70cc8ecd5243b45c20d9d3c1492d301145d0f4b3965042cd'
AND (
token = 'Lq6EJvJG0IfYQz/tbbRc7/+1PInvlg9En4pfkpIxyyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)