UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hYg+lCsR8r8x4/mbPxNjDWMsSbHSeUbpEjgZ96kT+ZQ='
WHERE
key_id = '0c6cc9bc4fc2a176ff4979cd0babf8d1ec8c8435a558b6ca10f761c93e9219ee'
AND (
token = 'hYg+lCsR8r8x4/mbPxNjDWMsSbHSeUbpEjgZ96kT+ZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)