UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kyGHSxA0ZqzKznrUnPh3exzF8c6VWoNeteugk9N+YUU='
WHERE
key_id = 'bdfb89f9feaf84fabe827299dfdddc0e0d42e7fa296c0889596f856fb8f7a99b'
AND (
token = 'kyGHSxA0ZqzKznrUnPh3exzF8c6VWoNeteugk9N+YUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)