UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XHvFIlFiBXb8cZJywQ1Z46VbEgUhxoVDc7FKJGwNFA='
WHERE
key_id = '02e6abb1426599516e2a50d1a149b94114e10644fbc3b01d43fe495ca995a27c'
AND (
token = '9XHvFIlFiBXb8cZJywQ1Z46VbEgUhxoVDc7FKJGwNFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)