UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2XB1jb+O4gWjv2Mspdpb07Z3WE+SUlmFJlWj8fuwzcI='
WHERE
key_id = '05cd496215c2a0919670c37d4ca3f2880d6a09189162acaf05ae7960217d10ee'
AND (
token = '2XB1jb+O4gWjv2Mspdpb07Z3WE+SUlmFJlWj8fuwzcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)