UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Zxe1mfr+qINeHz/Bg4TFEXRzilY+IHG9hW6r8N7jIc='
WHERE
key_id = 'ba78fa09481192d57d9955d84baa3e7090513673c6444c4650e7427d22279e8c'
AND (
token = '8Zxe1mfr+qINeHz/Bg4TFEXRzilY+IHG9hW6r8N7jIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)