UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aJBIxDlswfu0pLL0fTdjdfpl7NNUnvfu8FSxoT6Co7w='
WHERE
key_id = '1e734651a235fc104cb3ca80568cd8627919fa159606604f25a5801e7a3e306d'
AND (
token = 'aJBIxDlswfu0pLL0fTdjdfpl7NNUnvfu8FSxoT6Co7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)