UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DG91u7QagatqagV1mbNHMbuS0R/92BM8G2UyC3bz5P0='
WHERE
key_id = '3af1b819dbf04d8e2d1a888094e09a4d300873afec0e36973519276ce28fa6ce'
AND (
token = 'DG91u7QagatqagV1mbNHMbuS0R/92BM8G2UyC3bz5P0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)