UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cB/6rgA7JfETuPvvD6YM4acHHxA6gh8u8guKX1DZjgc='
WHERE
key_id = 'a0c9c7241e62006f59be9afb6c835a08db077846d986d380d09af22102991942'
AND (
token = 'cB/6rgA7JfETuPvvD6YM4acHHxA6gh8u8guKX1DZjgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)