UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qY+CEXcj1iWUnm/p3rld9LwZkZ3v0o7I1gz1sH3Nu4w='
WHERE
key_id = 'ae12078b6a03fb632c0f504305498b3cabfb41f8e58067d0181ab3d884f67a80'
AND (
token = 'qY+CEXcj1iWUnm/p3rld9LwZkZ3v0o7I1gz1sH3Nu4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)