UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xRfKuKM2O8bGOebv64wvYPianxzM49eIaISBOTVS/c='
WHERE
key_id = 'cb15b7e27315996c30be425f786432b0eb1f2f5922550fc163f13395d3ce025a'
AND (
token = '0xRfKuKM2O8bGOebv64wvYPianxzM49eIaISBOTVS/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)