UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hZDK8XTM4htQuyjPlSdR7/ReRqxBLQWspjC6cE1DtU='
WHERE
key_id = '01df7101665f794b467591f2152bee8578cf9a8e0356f90507a5acbc636ef523'
AND (
token = '1hZDK8XTM4htQuyjPlSdR7/ReRqxBLQWspjC6cE1DtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)