UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yr1YSrGHDXtrypLO7r43BnY6wcbnsXD+ddhcLy94HZA='
WHERE
key_id = 'ae7453c6953a9b67b93e4839ce033e785db22961043e15770efe7d68ee0a7ba1'
AND (
token = 'yr1YSrGHDXtrypLO7r43BnY6wcbnsXD+ddhcLy94HZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)