UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MDgCKAQwBeRpXh99mJYFU5gpg5kiiDIoW8PnAkgFJPo='
WHERE
key_id = 'e6590299f2cc928b9d79e5eda6a7de51bff2e58a270ebb379b199f85a0531c1f'
AND (
token = 'MDgCKAQwBeRpXh99mJYFU5gpg5kiiDIoW8PnAkgFJPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)