UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zn1D3L5u1C0jHvTO7sXh3d1qschiich6EM22Ley/Rnw='
WHERE
key_id = '5c026d0fefd00ce4e86f1d49c92f62e97ca2a30a4211587061bd54f64e37cb99'
AND (
token = 'zn1D3L5u1C0jHvTO7sXh3d1qschiich6EM22Ley/Rnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)