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